Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/vfberror.sql

Text File | 2000-05-12 | 380b | 14 lines

/*
This view looks at fberror and separates the errors into Crash and other errors.
*/
create or replace view vfberror as
select 'CRASH' Flag, det_seq_num, farebox_glid, err_string, conv_date
from fberror
where err_string like '%CRASH%'
union
select '     ' Flag, det_seq_num, farebox_glid, err_string, conv_date
from fberror
where err_string not like '%CRASH%';